{
  "properties" : { },
  "id" : "b844a90a56764f27be065dc1616a6935",
  "script" : null,
  "groupId" : "fba8d4bd351f4b8f9bbbff87230b9af7",
  "name" : "去重当天日期",
  "createTime" : null,
  "updateTime" : 1666161566149,
  "lock" : null,
  "createBy" : null,
  "updateBy" : null,
  "path" : "/distinct",
  "method" : "POST",
  "parameters" : [ ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"code\": 1,\n    \"message\": \"success\",\n    \"data\": [{\n        \"ID\": 16,\n        \"username\": \"黄云松\",\n        \"groupname\": \"交付中心（东部）\",\n        \"download_number\": 2,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx\",\n        \"asset_library\": \"知识库\",\n        \"download_date\": \"2022-10-21\"\n    }, {\n        \"ID\": 15,\n        \"username\": \"黄云松\",\n        \"groupname\": \"交付中心（东部）\",\n        \"download_number\": 1,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-过敏信息.sql\",\n        \"asset_library\": \"测评库\",\n        \"download_date\": \"2022-10-07\"\n    }, {\n        \"ID\": 10,\n        \"username\": \"刘家铭\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 5,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx\",\n        \"asset_library\": \"标准库\",\n        \"download_date\": \"2022-10-12\"\n    }, {\n        \"ID\": 11,\n        \"username\": \"刘家铭\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 3,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-过敏信息.sql\",\n        \"asset_library\": \"标准库\",\n        \"download_date\": \"2022-10-07\"\n    }, {\n        \"ID\": 6,\n        \"username\": \"李卫国\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 44,\n        \"file_name\": \"患者基本信息数据表.docx\",\n        \"asset_library\": \"知识库\",\n        \"download_date\": \"2022-10-06\"\n    }, {\n        \"ID\": 4,\n        \"username\": \"李卫国\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 3,\n        \"file_name\": \"患者基本信息数据表.docx\",\n        \"asset_library\": \"知识库\",\n        \"download_date\": \"2022-10-01\"\n    }, {\n        \"ID\": 13,\n        \"username\": \"焦建\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 3,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-过敏信息.sql\",\n        \"asset_library\": \"知识库\",\n        \"download_date\": \"2022-09-09\"\n    }, {\n        \"ID\": 1,\n        \"username\": \"焦建\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 2,\n        \"file_name\": \"测试文件\",\n        \"asset_library\": \"工具库\",\n        \"download_date\": \"2022-10-01\"\n    }, {\n        \"ID\": 12,\n        \"username\": \"焦建\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 2,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx\",\n        \"asset_library\": \"工具库\",\n        \"download_date\": \"2022-10-01\"\n    }, {\n        \"ID\": 3,\n        \"username\": \"王琦\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 3,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx\",\n        \"asset_library\": \"知识库\",\n        \"download_date\": \"2022-10-05\"\n    }, {\n        \"ID\": 2,\n        \"username\": \"王琦\",\n        \"groupname\": \"解决方案开发组\",\n        \"download_number\": 1,\n        \"file_name\": \"襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx\",\n        \"asset_library\": \"工具库\",\n        \"download_date\": \"2022-10-28\"\n    }],\n    \"timestamp\": 1666161213200,\n    \"executeTime\": 80\n}",
  "description" : null,
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : {
    "name" : "",
    "value" : "",
    "description" : "",
    "required" : false,
    "dataType" : "Object",
    "type" : null,
    "defaultValue" : null,
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ {
      "name" : "code",
      "value" : "1",
      "description" : "",
      "required" : false,
      "dataType" : "Integer",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "message",
      "value" : "success",
      "description" : "",
      "required" : false,
      "dataType" : "String",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "data",
      "value" : "",
      "description" : "",
      "required" : false,
      "dataType" : "Object",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ {
        "name" : "",
        "value" : "",
        "description" : "",
        "required" : false,
        "dataType" : "Object",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ {
          "name" : "ID",
          "value" : "16",
          "description" : "",
          "required" : false,
          "dataType" : "Integer",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "username",
          "value" : "黄云松",
          "description" : "",
          "required" : false,
          "dataType" : "String",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "groupname",
          "value" : "交付中心（东部）",
          "description" : "",
          "required" : false,
          "dataType" : "String",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "download_number",
          "value" : "2",
          "description" : "",
          "required" : false,
          "dataType" : "Integer",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "file_name",
          "value" : "襄阳-东软二中心云his3.0-v5.6.0-患者基本信息数据表.docx",
          "description" : "",
          "required" : false,
          "dataType" : "String",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "asset_library",
          "value" : "知识库",
          "description" : "",
          "required" : false,
          "dataType" : "String",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        }, {
          "name" : "download_date",
          "value" : "2022-10-21",
          "description" : "",
          "required" : false,
          "dataType" : "String",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ ]
        } ]
      } ]
    }, {
      "name" : "timestamp",
      "value" : "1666161213200",
      "description" : "",
      "required" : false,
      "dataType" : "Long",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "executeTime",
      "value" : "80",
      "description" : "",
      "required" : false,
      "dataType" : "Integer",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    } ]
  }
}
================================
import log;
var sql = """ 
select DISTINCT file_name,username from file_download_number 
    where download_date = current_date() order by groupname desc
"""
return db.select(sql)